``Import Competition and Skill Content in U.S. Manufacturing Industries.''
Yi Lu and Travis Ng
Review of Economics and Statistics 2013 95:4, 1404-1417 

The RESTAT_Replication.do file replicates the figure as well as all the tables in the paper using Stata version 12.

The data file is: REStat.dta

For generating Figure 1, we obtain data on net exports from:
http://faculty.som.yale.edu/peterschott/sub_international.htm
and use data ``SIC87-level U.S. import and export data, 1972-2005 (SIC or NAICS x country x year; Stata format).''
These data are described by Peter K. Schott in 
http://faculty.som.yale.edu/peterschott/files/research/data/sic_naics_trade_20100504.pdf

The file's name is: xm_sic87_72_105_20100504.dta

------------------------------------------

Data dictionary for REStat.dta
ind7090         int    %9.0g                  Consistent 70-90 Industry Code, fr David Autor
                                                (3-digit)
year            int    %ty                    
mer             float  %9.0g                  import-weighted 2-digit SIC-specific exchange
                                                rate from Linda Goldberg
im_pen_uk       float  %9.0g                  uk import penetration ratio
im_pen_nochin~k float  %9.0g                  uk import penetration ratio from non-low-wage countries
im_pen_noloww~k float  %9.0g                  uk import penetration ratio from everywhere except China
ln_cap_emp      float  %9.0g                  Ln(Real capital stock per worker($1000s))
ln_cap_prode    float  %9.0g                  Ln(Real capital stock per prod. worker($1000s))
ln_cap_prodh    float  %9.0g                  Ln(Real capital stock per prod. worker hr($/hr))
ln_equip_prodh  float  %9.0g                  Ln(Real equipment stock per prod. worker hr($/hr))
ln_equip_emp    float  %9.0g                  Ln(Real equipment stock per worker($1000s))
ln_emp          float  %9.0g                  Ln(worker($1000s))
ln_vship        float  %9.0g                  Ln(value of shipment ($1000s))
ln_vship_emp    float  %9.0g                  Ln(value of shipment per worker ($1000s))
yr1             byte   %8.0g                  year== 1958.0000
yr2             byte   %8.0g                  year== 1959.0000
yr3             byte   %8.0g                  year== 1960.0000
yr4             byte   %8.0g                  year== 1961.0000
yr5             byte   %8.0g                  year== 1962.0000
yr6             byte   %8.0g                  year== 1963.0000
yr7             byte   %8.0g                  year== 1964.0000
yr8             byte   %8.0g                  year== 1965.0000
yr9             byte   %8.0g                  year== 1966.0000
yr10            byte   %8.0g                  year== 1967.0000
yr11            byte   %8.0g                  year== 1968.0000
yr12            byte   %8.0g                  year== 1969.0000
yr13            byte   %8.0g                  year== 1970.0000
yr14            byte   %8.0g                  year== 1971.0000
yr15            byte   %8.0g                  year== 1972.0000
yr16            byte   %8.0g                  year== 1973.0000
yr17            byte   %8.0g                  year== 1974.0000
yr18            byte   %8.0g                  year== 1975.0000
yr19            byte   %8.0g                  year== 1976.0000
yr20            byte   %8.0g                  year== 1977.0000
yr21            byte   %8.0g                  year== 1978.0000
yr22            byte   %8.0g                  year== 1979.0000
yr23            byte   %8.0g                  year== 1980.0000
yr24            byte   %8.0g                  year== 1981.0000
yr25            byte   %8.0g                  year== 1982.0000
yr26            byte   %8.0g                  year== 1983.0000
yr27            byte   %8.0g                  year== 1984.0000
yr28            byte   %8.0g                  year== 1985.0000
yr29            byte   %8.0g                  year== 1986.0000
yr30            byte   %8.0g                  year== 1987.0000
yr31            byte   %8.0g                  year== 1988.0000
yr32            byte   %8.0g                  year== 1989.0000
yr33            byte   %8.0g                  year== 1990.0000
yr34            byte   %8.0g                  year== 1991.0000
yr35            byte   %8.0g                  year== 1992.0000
yr36            byte   %8.0g                  year== 1993.0000
yr37            byte   %8.0g                  year== 1994.0000
yr38            byte   %8.0g                  year== 1995.0000
yr39            byte   %8.0g                  year== 1996.0000
yr40            byte   %8.0g                  year== 1997.0000
yr41            byte   %8.0g                  year== 1998.0000
yr42            byte   %8.0g                  year== 1999.0000
yr43            byte   %8.0g                  year== 2000.0000
yr44            byte   %8.0g                  year== 2001.0000
id1             byte   %8.0g                  ind7090== 100.0000
id2             byte   %8.0g                  ind7090== 101.0000
id3             byte   %8.0g                  ind7090== 102.0000
id4             byte   %8.0g                  ind7090== 110.0000
id5             byte   %8.0g                  ind7090== 111.0000
id6             byte   %8.0g                  ind7090== 112.0000
id7             byte   %8.0g                  ind7090== 120.0000
id8             byte   %8.0g                  ind7090== 121.0000
id9             byte   %8.0g                  ind7090== 122.0000
id10            byte   %8.0g                  ind7090== 130.0000
id11            byte   %8.0g                  ind7090== 132.0000
id12            byte   %8.0g                  ind7090== 140.0000
id13            byte   %8.0g                  ind7090== 141.0000
id14            byte   %8.0g                  ind7090== 142.0000
id15            byte   %8.0g                  ind7090== 150.0000
id16            byte   %8.0g                  ind7090== 151.0000
id17            byte   %8.0g                  ind7090== 152.0000
id18            byte   %8.0g                  ind7090== 160.0000
id19            byte   %8.0g                  ind7090== 161.0000
id20            byte   %8.0g                  ind7090== 162.0000
id21            byte   %8.0g                  ind7090== 171.0000
id22            byte   %8.0g                  ind7090== 172.0000
id23            byte   %8.0g                  ind7090== 180.0000
id24            byte   %8.0g                  ind7090== 181.0000
id25            byte   %8.0g                  ind7090== 182.0000
id26            byte   %8.0g                  ind7090== 190.0000
id27            byte   %8.0g                  ind7090== 191.0000
id28            byte   %8.0g                  ind7090== 192.0000
id29            byte   %8.0g                  ind7090== 200.0000
id30            byte   %8.0g                  ind7090== 201.0000
id31            byte   %8.0g                  ind7090== 211.0000
id32            byte   %8.0g                  ind7090== 212.0000
id33            byte   %8.0g                  ind7090== 220.0000
id34            byte   %8.0g                  ind7090== 221.0000
id35            byte   %8.0g                  ind7090== 222.0000
id36            byte   %8.0g                  ind7090== 230.0000
id37            byte   %8.0g                  ind7090== 231.0000
id38            byte   %8.0g                  ind7090== 241.0000
id39            byte   %8.0g                  ind7090== 242.0000
id40            byte   %8.0g                  ind7090== 250.0000
id41            byte   %8.0g                  ind7090== 251.0000
id42            byte   %8.0g                  ind7090== 252.0000
id43            byte   %8.0g                  ind7090== 261.0000
id44            byte   %8.0g                  ind7090== 262.0000
id45            byte   %8.0g                  ind7090== 270.0000
id46            byte   %8.0g                  ind7090== 271.0000
id47            byte   %8.0g                  ind7090== 272.0000
id48            byte   %8.0g                  ind7090== 280.0000
id49            byte   %8.0g                  ind7090== 281.0000
id50            byte   %8.0g                  ind7090== 282.0000
id51            byte   %8.0g                  ind7090== 290.0000
id52            byte   %8.0g                  ind7090== 291.0000
id53            byte   %8.0g                  ind7090== 300.0000
id54            byte   %8.0g                  ind7090== 301.0000
id55            byte   %8.0g                  ind7090== 310.0000
id56            byte   %8.0g                  ind7090== 311.0000
id57            byte   %8.0g                  ind7090== 312.0000
id58            byte   %8.0g                  ind7090== 320.0000
id59            byte   %8.0g                  ind7090== 321.0000
id60            byte   %8.0g                  ind7090== 322.0000
id61            byte   %8.0g                  ind7090== 331.0000
id62            byte   %8.0g                  ind7090== 332.0000
id63            byte   %8.0g                  ind7090== 340.0000
id64            byte   %8.0g                  ind7090== 341.0000
id65            byte   %8.0g                  ind7090== 342.0000
id66            byte   %8.0g                  ind7090== 350.0000
id67            byte   %8.0g                  ind7090== 351.0000
id68            byte   %8.0g                  ind7090== 360.0000
id69            byte   %8.0g                  ind7090== 361.0000
id70            byte   %8.0g                  ind7090== 362.0000
id71            byte   %8.0g                  ind7090== 370.0000
id72            byte   %8.0g                  ind7090== 371.0000
id73            byte   %8.0g                  ind7090== 372.0000
id74            byte   %8.0g                  ind7090== 380.0000
id75            byte   %8.0g                  ind7090== 381.0000
id76            byte   %8.0g                  ind7090== 391.0000
id77            byte   %8.0g                  ind7090== 392.0000
ln_im_pen       float  %9.0g                  Ln(Import penetration ratio)
ln_nonlw_im_pen float  %9.0g                  Ln(Import penetration ratio from non-low-wage countries)
ln_nonchinaim~n float  %9.0g                  Ln(Import penetration ratio from all EXCEPT China)
cognitive_non   float  %9.0g                  Scores for cognitive non-routine skill
interactive_non float  %9.0g                  Scores for interactive non-routine skill
cognitive_rou   float  %9.0g                  Scores for cognitive routine skill
manual_non      float  %9.0g                  Scores for manual non-routine skill
manual_rou      float  %9.0g                  Scores for manual routine skill
ratio           float  %9.0g                  ratio between non-production/production workers
_Iyear_1959     byte   %8.0g                  year==1959
_Iyear_1960     byte   %8.0g                  year==1960
_Iyear_1961     byte   %8.0g                  year==1961
_Iyear_1962     byte   %8.0g                  year==1962
_Iyear_1963     byte   %8.0g                  year==1963
_Iyear_1964     byte   %8.0g                  year==1964
_Iyear_1965     byte   %8.0g                  year==1965
_Iyear_1966     byte   %8.0g                  year==1966
_Iyear_1967     byte   %8.0g                  year==1967
_Iyear_1968     byte   %8.0g                  year==1968
_Iyear_1969     byte   %8.0g                  year==1969
_Iyear_1970     byte   %8.0g                  year==1970
_Iyear_1971     byte   %8.0g                  year==1971
_Iyear_1972     byte   %8.0g                  year==1972
_Iyear_1973     byte   %8.0g                  year==1973
_Iyear_1974     byte   %8.0g                  year==1974
_Iyear_1975     byte   %8.0g                  year==1975
_Iyear_1976     byte   %8.0g                  year==1976
_Iyear_1977     byte   %8.0g                  year==1977
_Iyear_1978     byte   %8.0g                  year==1978
_Iyear_1979     byte   %8.0g                  year==1979
_Iyear_1980     byte   %8.0g                  year==1980
_Iyear_1981     byte   %8.0g                  year==1981
_Iyear_1982     byte   %8.0g                  year==1982
_Iyear_1983     byte   %8.0g                  year==1983
_Iyear_1984     byte   %8.0g                  year==1984
_Iyear_1985     byte   %8.0g                  year==1985
_Iyear_1986     byte   %8.0g                  year==1986
_Iyear_1987     byte   %8.0g                  year==1987
_Iyear_1988     byte   %8.0g                  year==1988
_Iyear_1989     byte   %8.0g                  year==1989
_Iyear_1990     byte   %8.0g                  year==1990
_Iyear_1991     byte   %8.0g                  year==1991
_Iyear_1992     byte   %8.0g                  year==1992
_Iyear_1993     byte   %8.0g                  year==1993
_Iyear_1994     byte   %8.0g                  year==1994
_Iyear_1995     byte   %8.0g                  year==1995
_Iyear_1996     byte   %8.0g                  year==1996
_Iyear_1997     byte   %8.0g                  year==1997
_Iyear_1998     byte   %8.0g                  year==1998
_Iyear_1999     byte   %8.0g                  year==1999
_Iyear_2000     byte   %8.0g                  year==2000
_Iyear_2001     byte   %8.0g                  year==2001
